Tabela DeletedServiceSet

Definicja tabeli DeletedServiceSet

Name

DeletedServiceSet

Code

DeletedServiceSet

Comment

 


Lista kolumn tabeli DeletedServiceSet

Name

Code

DeletedServiceSetID

DeletedServiceSetID

UserDefinitionID

UserDefinitionID

MessageID

MessageID

EpisodeID

EpisodeID

EpisodeEXTID

EpisodeEXTID

PatientID

PatientID

PatientTypeID

PatientTypeID

AccountDataID

AccountDataID

AccountDataEXTID

AccountDataEXTID

EventID

EventID

EventEXTID

EventEXTID

PerfDT

PerfDT

StatusID

StatusID


Kolumna DeletedServiceSetID tabeli DeletedServiceSet

Definicja kolumny DeletedServiceSetID tabeli DeletedServiceSet

Name

DeletedServiceSetID

Code

DeletedServiceSetID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UserDefinitionID tabeli DeletedServiceSet

Definicja kolumny UserDefinitionID tabeli DeletedServiceSet

Name

UserDefinitionID

Code

UserDefinitionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MessageID tabeli DeletedServiceSet

Definicja kolumny MessageID tabeli DeletedServiceSet

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli DeletedServiceSet

Definicja kolumny EpisodeID tabeli DeletedServiceSet

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

No

Comment

 


Kolumna EpisodeEXTID tabeli DeletedServiceSet

Definicja kolumny EpisodeEXTID tabeli DeletedServiceSet

Name

EpisodeEXTID

Code

EpisodeEXTID

Data Type

VARCHAR2(55)

Mandatory

No

Comment

 


Kolumna PatientID tabeli DeletedServiceSet

Definicja kolumny PatientID tabeli DeletedServiceSet

Name

PatientID

Code

PatientID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna PatientTypeID tabeli DeletedServiceSet

Definicja kolumny PatientTypeID tabeli DeletedServiceSet

Name

PatientTypeID

Code

PatientTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountDataID tabeli DeletedServiceSet

Definicja kolumny AccountDataID tabeli DeletedServiceSet

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountDataEXTID tabeli DeletedServiceSet

Definicja kolumny AccountDataEXTID tabeli DeletedServiceSet

Name

AccountDataEXTID

Code

AccountDataEXTID

Data Type

VARCHAR2(55)

Mandatory

No

Comment

 


Kolumna EventID tabeli DeletedServiceSet

Definicja kolumny EventID tabeli DeletedServiceSet

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna EventEXTID tabeli DeletedServiceSet

Definicja kolumny EventEXTID tabeli DeletedServiceSet

Name

EventEXTID

Code

EventEXTID

Data Type

VARCHAR2(55)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli DeletedServiceSet

Definicja kolumny PerfDT tabeli DeletedServiceSet

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StatusID tabeli DeletedServiceSet

Definicja kolumny StatusID tabeli DeletedServiceSet

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli DeletedServiceSet

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DeletedServiceSet

Definicja klucza Identifier_1 tabeli DeletedServiceSet

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment